Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2970
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.8 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qtde_invoices` and 3 other fields	High correlation
`recency_days` is highly correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 1 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qtde_products` is highly correlated with `qtde_invoices`	High correlation
`avg_ticket` is highly correlated with `qtde_returns` and 1 other fields	High correlation
`qtde_returns` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 2 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `qtde_items`	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 5 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_returns` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.45321988)	Skewed
`qtde_returns` is highly skewed (γ1 = 51.80645659)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.68007213)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtde_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2021-12-24 03:46:15.100409
Analysis finished	2021-12-24 03:47:03.950377
Duration	48.85 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2970
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2317.86532

Minimum	0
Maximum	5716
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.45
Q1	929.25
median	2120.5
Q3	3537.75
95-th percentile	5036.1
Maximum	5716
Range	5716
Interquartile range (IQR)	2608.5

Descriptive statistics

Standard deviation	1555.136615
Coefficient of variation (CV)	0.6709348474
Kurtosis	-1.010761417
Mean	2317.86532
Median Absolute Deviation (MAD)	1271
Skewness	0.3420323534
Sum	6884060
Variance	2418449.89
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3011	1	< 0.1%
2996	1	< 0.1%
2999	1	< 0.1%
3000	1	< 0.1%
3001	1	< 0.1%
3002	1	< 0.1%
3005	1	< 0.1%
3007	1	< 0.1%
3008	1	< 0.1%
Other values (2960)	2960	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5716	1	< 0.1%
5697	1	< 0.1%
5687	1	< 0.1%
5681	1	< 0.1%
5660	1	< 0.1%
5656	1	< 0.1%
5650	1	< 0.1%
5639	1	< 0.1%
5638	1	< 0.1%
5628	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2970
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.71818

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.45
Q1	13799.75
median	15220.5
Q3	16767.75
95-th percentile	17964.55
Maximum	18287
Range	5940
Interquartile range (IQR)	2968

Descriptive statistics

Standard deviation	1718.703373
Coefficient of variation (CV)	0.112548955
Kurtosis	-1.205496241
Mean	15270.71818
Median Absolute Deviation (MAD)	1487
Skewness	0.03170847426
Sum	45354033
Variance	2953941.285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2960)	2960	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2955
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2748.786333

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.8075
Q1	571.02
median	1088.53
Q3	2307.675
95-th percentile	7217.565
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1736.655

Descriptive statistics

Standard deviation	10578.88154
Coefficient of variation (CV)	3.848564516
Kurtosis	354.0627168
Mean	2748.786333
Median Absolute Deviation (MAD)	673.06
Skewness	16.7803378
Sum	8163895.41
Variance	111912734.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178.96	2	0.1%
533.33	2	0.1%
889.93	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
2092.32	2	0.1%
379.65	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
331	2	0.1%
Other values (2945)	2950	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.31346801

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.7564254
Coefficient of variation (CV)	1.20902243
Kurtosis	2.774045758
Mean	64.31346801
Median Absolute Deviation (MAD)	26
Skewness	1.797124381
Sum	191011
Variance	6046.061691
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2220	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.722222222

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.855180674
Coefficient of variation (CV)	1.547507302
Kurtosis	190.8917484
Mean	5.722222222
Median Absolute Deviation (MAD)	2
Skewness	10.7684025
Sum	16995
Variance	78.41422477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.4%
3	500	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	190	6.4%
2	785	26.4%
3	500	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1671
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1608.475758

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	102.45
Q1	296.25
median	640
Q3	1400.5
95-th percentile	4407.2
Maximum	196844
Range	196843
Interquartile range (IQR)	1104.25

Descriptive statistics

Standard deviation	5886.622254
Coefficient of variation (CV)	3.659751927
Kurtosis	466.1489505
Mean	1608.475758
Median Absolute Deviation (MAD)	421
Skewness	17.86145938
Sum	4777173
Variance	34652321.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
246	8	0.3%
288	8	0.3%
272	8	0.3%
84	8	0.3%
260	8	0.3%
114	7	0.2%
516	7	0.2%
Other values (1661)	2887	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.7020202

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.8536468
Coefficient of variation (CV)	2.199260015
Kurtosis	354.9723233
Mean	122.7020202
Median Absolute Deviation (MAD)	44
Skewness	15.71004775
Sum	364425
Variance	72820.99067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
35	35	1.2%
29	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2630	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2967
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.88713523

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.917434212
Q1	13.11982258
median	17.96548505
Q3	24.98612169
95-th percentile	90.49558333
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	11.86629911

Descriptive statistics

Standard deviation	1036.759927
Coefficient of variation (CV)	19.98105932
Kurtosis	2891.680514
Mean	51.88713523
Median Absolute Deviation (MAD)	5.975979236
Skewness	53.45321988
Sum	154104.7916
Variance	1074871.146
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	2	0.1%
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
31.5408046	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
21.47435897	1	< 0.1%
Other values (2957)	2957	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.33548719

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.92445055
median	48.26785714
Q3	85.33333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.40888278

Descriptive statistics

Standard deviation	63.53819113
Coefficient of variation (CV)	0.9436063178
Kurtosis	4.889533464
Mean	67.33548719
Median Absolute Deviation (MAD)	26.26785714
Skewness	2.063271059
Sum	199986.397
Variance	4037.101731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
46	17	0.6%
21	17	0.6%
11	17	0.6%
28	16	0.5%
Other values (1248)	2778	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1350
Distinct (%)	45.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06327225268

Minimum	0.005449591281
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009433962264
Q1	0.01777777778
median	0.02941176471
Q3	0.05539964304
95-th percentile	0.2222222222
Maximum	3
Range	2.994550409
Interquartile range (IQR)	0.03762186526

Descriptive statistics

Standard deviation	0.1344597893
Coefficient of variation (CV)	2.125098816
Kurtosis	121.5995649
Mean	0.06327225268
Median Absolute Deviation (MAD)	0.01433823529
Skewness	8.774791213
Sum	187.9185905
Variance	0.01807943493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1666666667	21	0.7%
0.3333333333	21	0.7%
0.02777777778	20	0.7%
0.09090909091	19	0.6%
0.0625	17	0.6%
0.1333333333	16	0.5%
0.4	16	0.5%
0.25	15	0.5%
0.02380952381	15	0.5%
0.03571428571	15	0.5%
Other values (1340)	2795	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	14	0.5%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	12	0.4%
0.6514745308	1	< 0.1%
0.6	1	< 0.1%

qtde_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.13670034

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100.55
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1512.241801
Coefficient of variation (CV)	24.33733676
Kurtosis	2766.459377
Mean	62.13670034
Median Absolute Deviation (MAD)	1
Skewness	51.80645659
Sum	184546
Variance	2286875.265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
8	43	1.4%
7	43	1.4%
Other values (204)	706	23.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1980
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.7846461

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2625
median	172.2916667
Q3	281.6442308
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.3817308

Descriptive statistics

Standard deviation	791.4234658
Coefficient of variation (CV)	3.168423192
Kurtosis	2256.28608
Mean	249.7846461
Median Absolute Deviation (MAD)	83.04166667
Skewness	44.68007213
Sum	741860.399
Variance	626351.1022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
86	9	0.3%
73	9	0.3%
82	9	0.3%
60	8	0.3%
88	8	0.3%
136	8	0.3%
75	8	0.3%
129	7	0.2%
Other values (1970)	2883	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	906
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.48420374

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.666666667
median	13.6
Q3	22.10714286
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.44047619

Descriptive statistics

Standard deviation	15.45771808
Coefficient of variation (CV)	0.8840961992
Kurtosis	29.32853391
Mean	17.48420374
Median Absolute Deviation (MAD)	6.6
Skewness	3.436505023
Sum	51928.08512
Variance	238.9410481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	42	1.4%
9	41	1.4%
8	39	1.3%
16	39	1.3%
14	38	1.3%
17	38	1.3%
5	36	1.2%
11	36	1.2%
7	36	1.2%
15	35	1.2%
Other values (896)	2590	87.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	35.500000	0.486111	40.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	27.250000	0.048780	35.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	23.187500	0.045699	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.136364	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	23.200000	0.054441	29.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.073569	399.0	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	35.700000	0.039106	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.315508	474.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
2960	5628	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	0.285714	6.0	645.000000	66.000000
2961	5638	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000
2962	5639	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
2963	5650	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
2964	5656	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
2965	5660	12479	473.20	11.0	1.0	382.0	30.0	15.773333	4.0	0.333333	34.0	382.000000	30.000000
2966	5681	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	1.000000	50.0	169.333333	4.666667
2967	5687	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	104.000000
2968	5697	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000
2969	5716	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	0.285714	196.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows